CONDITIONAL FORMATTING [Solved/Closed]

Report
Posts
5
Registration date
Thursday October 31, 2013
Status
Member
Last seen
October 31, 2013
-
Posts
5
Registration date
Thursday October 31, 2013
Status
Member
Last seen
October 31, 2013
-
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 replies


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
Posts
5
Registration date
Thursday October 31, 2013
Status
Member
Last seen
October 31, 2013

Still can't get it to work
Posts
5
Registration date
Thursday October 31, 2013
Status
Member
Last seen
October 31, 2013

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

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.

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.

Posts
5
Registration date
Thursday October 31, 2013
Status
Member
Last seen
October 31, 2013

Thank you, it has been so ling since I have done any conditional formatting.