Condtional Format Problem 1

[Binnit]

I have formatted 7 columns and 25 rows to highlight the max value in each row using CellValueIs=MAX($E10:$K10) and this works fine for rows where there is at least one value.

When it reaches a row of cells with all null values it considers them to be equally null and highlights all the cells in the row when I just want it to leave the existing formats, how can I trap the Null values and prevent it from doing this?

Thanks

If IT ain’t working Binnit and Reboot

 

[Binnit]

Sorry - should also mention this is using Excel 97

If IT ain’t working Binnit and Reboot

 

[xlbo]

1st condition

=SUM($E10:$K10)=0

set format as nothing

Then enter your MAX formula as the 2nd condition with appropriate formats

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Binnit]

Xlbo

Good try but not quite there!

Now it retains the original formats but
Where the sum of the row is greater than 0 it now formats the entire row according to the 2nd frmat construct.

My formats are:-
Original on worksheet
format light blue back /Black font

1) FormulaIs =SUM($E10:$K10)=0
None set (so retain original)

2) FormualIs =MAX($E10:$K10)
format Dark green back / White font


Any further ideas?



If IT ain’t working Binnit and Reboot

 

[Binnit]

OK got it!

It should be
2) Cell Value Is =MAX($E10:$K10)
format Dark green back / White font

Thanks for the pointer on the first bit



If IT ain’t working Binnit and Reboot