Excel gurus - Conditional Formatting

[flimper]

Please help, this is driving me nuts :evil:

I have this formula: =NOT(EXACT($I2,$AW2)) to highlight when two figures are different. The figures in I9 and AW9 are identical but it is still highlighting. Any ideas why?

 

[markeg]

EXACT() is only valid on strings - for Values just use = (for example =$A1=$B1) in the conditional formatting statement

 

[flimper]

Thanks Mark, I now have =$I2=$AW2 on these cells =$AW$2:$AW$65 but not working still. I really don't know what I'm doing

 

[markeg]

Can you send the spreadsheet through? I've highlighted an example here, if it helps?

 

[flimper]

How do I send the sheet through? Says invalid file extension.

 

[markeg]

Sorry, slightly better example:

 

[markeg]

sent a pm....

 

[flimper]

replied

 

[Jaw]

could simplify it to =if($i2=$aw2,0,1) then apply it to your range, should work

Also, for ease, make sure that you set up the format on row 2 then change the range it is applied to, rather than selecting the range then creating a new rule; otherwise it will create the rule in a way that that the entire range could be looking at cells relative to the one you had selected when you entered the rule