conditional formatting

G

gailb14

I have a row with 3 cells.
The last cell will contain a date.
When that cell is filled in, I want all three cells to turn green.

I can do the formatting for the last cell but do not know how to do it
for the first two.'

Help
 
G

Gord Dibben

One method........

Select A1, A2 and A3

Format>CF>Formula is: =ISNUMBER($A$3) Note the $ signs to lock A3

Format to a green pattern and OK.

No date in A3.......no green color on any cell.


Gord Dibben MS Excel MVP
 
G

gailb14

I either don't understand or I am not doing it right.

Under conditional formatting there is
Cell Value Is (condition) then cells.

in the cells part I put the formula but it did not work.

Hel
 
L

LTUser54

you wrote:

Under conditional formatting there is
Cell Value Is (condition) then cells.

but there is another choice if you click to the right of that littl
window. Choose the "Formula is" one and try again....

Mark
Bosto
 
H

HR157

I would like to format all words that said “customer” in a column to
chosen color.Can anyone provide a formula or conditional formattin
that will do
this
 
Top