I have an excel table that looks like this (but bigger).
If the values in the 2nd, 4th and 6th column are bigger than 0.25, I want the value in the previous column to be red with conditional formatting, like so:
I got pretty far with this question
Conditional formatting based on several columns
using formula =$C$4>0,25 applied to =$B$4
But this only works for one cell. How do I apply this to the entire file?