CODEWITHSUNDEEP
excelexcel-2007conditional-formatting
AllisonC
AllisonC

Reputation: 3099

Why is my conditional formatting not working?

Conditional Formatting Rule enter image description here

Data

enter image description here

I want the value under Total Hours to be highlighted if it is less than the value under Expected Hours for every row.

Upvotes: 1

Views: 29340

Answers (2)

user4039065
user4039065

Reputation:

If the Applies to: is to remain `$E:$E, then the formula should be based on,

=AND(ROW()>1, $E1<$F1)

    CF Time comaprision

The additional ROW()>1 condition is actually not needed for your layout as Total Hours is considered greater than Expected Hours but if the column label in E1 started with a letter less than the E in F1's Expected Hours it would actually trigger a false positive.

Upvotes: 2

sancho.s ReinstateMonicaCellio
sancho.s ReinstateMonicaCellio

Reputation: 15561

You probably have to use =E2<F2 in the formula (with relative references).

Check this and note 1 in this answer.

Upvotes: 0

Related Questions