Hi All, I need some help with formatting a cell.
What I think I basically want is... if today is greater or equal to (another cell with date) + 5 days AND the cell is blank turn cell red. I would imagine this is something along the lines of IF TODAY > OR = H3 + 5 AND ''blank'' turn cell red (sorry am not great on writing formulas at all!! Any help would be greatly appreciated.
Hi and welcome to the board
I suppose the cell were the formula should be inserted is the one to test ( say A1)
so tryas formula for your CF=and(today()>H3+5,A1="")
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Hello,
you need a conditional format with a formula. Select the cell that you want to format, for example cell L3 and enter this formula
=AND(TODAY()>H3+5,ISBLANK(L3))
Depending on whether or not you want to apply the format to other cells, you will need to make the row and/or column references absolute.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks