condition format is not working for cell range...

[Ajinkya]

Dear Friends,


Pls suggest in Conditional format:


e.g.


A6=0


Rule Type:

Use a formula to determine which cells to format


Edit the rule Description:

=A6=0


Format:

Fill "Blue" color


applies to cell range


=$B$6:$X$6


but only cell B6 got highlighted with Blue instead of selected cell range.


Thanks in advance.

 

[SirJB7]

Hi, Ajinkya!

Tried changing this:

=A6=0

by this:

=$A6=0

?

Regards!

 

[Ajinkya]

Dear SirJB7,

That why you are "Excel Ninja"

Thanks it done

 

[SirJB7]

Hi, Ajinkya!

Glad you solved it. Thanks for your feedback and for your kind words too. Welcome back whenever needed or wanted.

Regards!

PS: BTW, it was just a matter of $