conditional format formula needed

RickeyS

Board Regular
Joined
Jun 23, 2006
Messages
222
I need a formula to put in conditional format that will lookup and match text on sheet Vac column A and if column C same row is blank do nothing but if column C is not blank turn the cell a color.

Thanks
Rick
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

ravishankar

Well-known Member
Joined
Feb 23, 2006
Messages
3,566
Hi
In format menu, choose conditional formatting
choose "cell value is" and "not equal to" and "0" on the top row
choose the color you want from the option available and click OK
If the cell is not blank it turns to the colour you want

I am not clear what you want to do if cell in c column has value but does not match on column A
Ravi
 

Watch MrExcel Video

Forum statistics

Threads
1,113,861
Messages
5,544,723
Members
410,630
Latest member
JFORTH97
Top