CONDITIONAL FORMATTING Solved/Closed

Question

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

ac3mark · Answer

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 · Answer

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

ac3mark · Answer

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.

ac3mark · Answer

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.

KGRIFFITH · Answer

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

CONDITIONAL FORMATTING

5 responses

Similar discussions

Subscribe To Our Newsletter!