Conditional Formatting

[niting]

Hi forum,


A small query!!


I want to highlit a range of cells, say B1:B26, based on the value being "1" in cells D1:D26.


When i apply CF using formula, the result is not coming, i am applying the following to range b1:b26

=countif(d1:d26,"1")>0


But I am not getting the result, could you please guide me where I am making mistake???


Thanks

 

[Hui]

Niting

You are close

try: =COUNTIF($D$1:$D$26,1)>0

This will highlight all the cells in B1:B26 if any cell is 1


If you want to highlight the same cell eg B10 when D10 is 1

use: =D1=1

 

[niting]

Hui,


I have to say that u rock!!! More than the solution provided, u had an idea what problem i am facing and what question i am asking, This is why u posted an alternative solution.


Thanks Hui.

Hui, however, when i am using =D1=1 and applying it to the range B1:C26, it only hilits the B column and not the C column. Any Idea??


Thanks

 

[Hui]

If you want B10 and C10 formatted when there is a 1 in D10 use

=$D1=1


If you use =D1=1 it will do that for column B as you saw and it will be looking at col E for a 1 to format Col C