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
KGRIFFITH Posts 5 Registration date Thursday October 31, 2013 Status Member Last seen October 31, 2013 - Oct 31, 2013 at 11:29 AM
Related:
- CONDITIONAL FORMATTING
- How to clear formatting in excel - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Phone formatting software for pc - Download - File management
5 responses
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
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:28 AM
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
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.
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.
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?
Ask a question
KGRIFFITH
Posts
5
Registration date
Thursday October 31, 2013
Status
Member
Last seen
October 31, 2013
Oct 31, 2013 at 11:29 AM
Oct 31, 2013 at 11:29 AM
Thank you, it has been so ling since I have done any conditional formatting.
Oct 31, 2013 at 10:51 AM