conditional formating affecting fill color

J

James R-S

When creating the condition select the "Formula" option, not "Cell Value".

Then you can put in any formula you like in the text box.

I use R1C1 mode so I would have something like: "=RC6>7". Then regardless of
the cell that I'm on it will look at column 6 of the row I'm on to see if it
is greater than 7.

Easy.

James R-S.
 
G

Gord Dibben

More detail please.

The CF must be entered in the cell you want colored, but you can use the value
of another cell to CF color a cell.

i.e. you can have A1 colored based upon the value in B1

Select A1 then Format>CF>Formula is: =B1="hoohah"

Gord Dibben Excel MVP

On Tue, 9 Nov 2004 23:44:03 -0800, "Ahmad Hakim" <Ahmad
 
Top