# CONDITIONAL FORMATTING

Solved/Closed
KGRIFFITH Posts 5 Registration date Thursday October 31, 2013 Status Member Last seen October 31, 2013 - Oct 31, 2013 at 10:23 AM
KGRIFFITH Posts 5 Registration date Thursday October 31, 2013 Status Member Last seen October 31, 2013 - Oct 31, 2013 at 11:29 AM
I need a formula stating that if cell R7 is blank, then Q7 is yellow.

So if anything is entered in R7 then the cell Q7 is no color

## 5 responses

Blocked Profile
Oct 31, 2013 at 10:25 AM
Good Morning,

That is conditional formatting, and it is accessable in the toolbar under "Conditional Formatting"

Select the cell that you want the format, then write the logic in the first box, and set the condition if it is true.

Let us know if you have any problems with this.

Have Fun!

//ark
-Contributor
KGRIFFITH Posts 5 Registration date Thursday October 31, 2013 Status Member Last seen October 31, 2013
Oct 31, 2013 at 10:51 AM
Still can't get it to work
KGRIFFITH Posts 5 Registration date Thursday October 31, 2013 Status Member Last seen October 31, 2013
Oct 31, 2013 at 10:28 AM
I tried, but I don't know how to write it if it is a different cell. It looks like it is only allowing if c7 is () , then c7 is red
Blocked Profile
Oct 31, 2013 at 10:49 AM
Highlite whatever cells you wish to have the formatting, all of the highlited cells will use the same format.

Then wwirte the logic in the condition as in cell [Q7]{=if(r7="",True,False)}

Then write the conditional formatting if Cell Q7 = True, Red.
Blocked Profile
Oct 31, 2013 at 11:04 AM
Try this.....

Click on the cell that you wish to have the highlite (Q7).....

Click on Conditional Formatting

Click on Highlite Cell Rules, then More rules

Then click on use a Formula to Determine what cells to format

In the next formula line, put the formula of =IF(R7="",TRUE, FALSE)

In the Formatting box, Select the type of Formatting to use.

That is it.

Didn't find the answer you are looking for?