#1
|
|||
|
|||
Conditional Formatting Formula
Hopefully a simple one, i need to create a formula with conditional formatting to show the below. I have 5 different ones to set up, but they will do the same thing I want to have 4 cells shaded in with colour if 1 cell is blank. L8 to O8 cells are shaded in if F8 is blank P8 to S8 cells are shaded in if G8 is blank T8 to W8 cells are shaded in if H8 is blank X8 to AA8 cells are shaded in if I8 is blank X8 to AA8 cells are shaded in if J8 is blank The formulas will fill in the four cells with colour and then when a cost is entered in the single cell it will change the 4 cells to white This is something i will hopefully use through the length of the workbook, i have done something like this before, but cant remember what formula i used Can anyone help? |
#2
|
||||
|
||||
Try =F8=" "
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dragging conditional formatting like a formula | sjp1966 | Excel | 9 | 04-13-2017 06:01 AM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Formula/Conditional Formatting | teza2k06 | Excel | 1 | 04-15-2014 06:49 PM |
Need formula for search and conditional formatting | MikeJedi | Excel | 9 | 01-13-2012 12:38 PM |
conditional formatting formula | NEHicks503 | Excel | 1 | 11-30-2011 09:01 AM |