Conditional Formatting using formula.

Hello guys.
Good Day!
This is in relation with my previous post.
http://www.excelfox.com/forum/f2/fil...cal-value-794/

My problem is.
How to format cells with this condition.
1. format the cells with green color from the first inputed cell till B6 will be reach
2. any value that will be inputted beyond the green line will be filled with red
Her is my workbook.

Hi,

Select E3:N3, in CF,

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

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

Quote:

---

Originally Posted by Admin

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