Link to home
Start Free TrialLog in
Avatar of RDLFC
RDLFC

asked on

conditional formating excel 2007

I have an attached excel sheet table with years as the column heading and values and letters as row headings.

Notice the unpopulated cells in column E (2012) are shaded red.  I want to build a conditional format that will determine if by the 1 of January each year (column heading) the cells below are not populated that the fill of the cells will turn red.  

Once populated the fill will turn white.
example.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Lee Wadwell
Lee Wadwell
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial