View Single Post
 
Old 08-22-2014, 01:43 AM
teza2k06 teza2k06 is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2013
Posts: 37
teza2k06 is on a distinguished road
Default 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?
Reply With Quote