Hi, I am trying to create a database that automatically highlights different colours depending on certain criteria
Apologies but i cannot link to the workbook as it contains an awful lot of protected data and it would take me a long time to create a version with no data for the purposes of this thread as all the sheets link together in one way or another.
CF help.PNG
Row 6 data comes from another sheet based on information in cell E4 drop down.
I have set up a formula in row 5 =COUNTIF($6:$6,F3) which compares row 6 to row 3 and places a 1 in the cell in row 5 if the data is found in row 3. i.e Child protection lvl1 is in row 6 so throws up a '1' in cell G5. (If there is a better way fo doing this, I am all ears!)
Based on these findings from the formulas in row 5, I need cells in row 4 to be conditionally formatted as follows:
- If cell ?5 is blank/empty, then the cell should be grey
- if cell ?5 has a 1 in it, then it should be white
THEN
- if there is a date in cell ?4 then conditionally formatted to highlight the cell red, yellow or green based on the dates proximity to today.
However, for some reason, I cannot get cells in row 4 to highlight grey if the cells in row 5 are blank/empty, I assume because there is a formula in there and they aren't really blank. I have tried <> instead of =, and ISBLANK but nothing seems to work.
This is my current set up.
CF rules.PNG
Any help would be greatly appreciated.
I am not the best at excel, i am completely self taught so try and explain it simply if its complicated
Thanks
Bookmarks