Conditional Format

K

Kevin

How do I do a conditional format saying that if A6 has nothing in it then
turn J6 a certain colour.
 
E

Eduardo

Hi,
position in cell J6, conditional formating, where the formula is enter

a6="" and choose your color
 
T

T. Valko

Try this...

Select cell J6
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=A6=""
Click the Format button
Select the desired style(s)
OK out
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting files & folders 0
conditional formating for the whole row, based on one cell value 2
Mail Merge Directory Conditional Page Break 0
Conditional Formatting question.... 1
Formula Problem with IF (Negative and Positive Numbers) 2
Conditional formatting disappears when cell contents deleted 2
Is it possible to edit colours already saved as part of a custom theme? 0
Change the colour of a neighbouring cell 6

Top