Conditional Formatting using formula.

[Admin]

Hi,

Select E3:N3, in CF,

=COLUMNS($E$3:E3)<=$B$3 ===> format green

=COLUMNS($E$3:E3)>$B$3 ===> format red

[Ryan_Bernal]

Hi,

Select E3:N3, in CF,

=COLUMNS($E$3:E3)<=$B$3 ===> format green

=COLUMNS($E$3:E3)>$B$3 ===> format red

Thanks Admin. Unfortunately, that's not the exact thing that i want to do. I want to format the cell range E3:N3 with the ff condition.
The starting point should be the first cell with numerical value. Let say I input number on F3 and cell B6 is equal to 6.From F2 to k2 it will be filled with green beyond the k2, cell will be format to red when user input a value on those cells. I am hoping that my problem is clear. Thanks Admin as always. More power.















;e3