IF column C is > 14 days of todays date, turn red. if not, turn yellow.
Hello, im doing RFI logs for architecture, and i cant seem to write a formula that can cover all of my requirements.
there are 2 days, day rec'vd (column C) and also sent (column H)
i need to be able to have it to where if column C is 14 days old, then the column will turn red
if it is not 14 days old, it is yellow
(this is if column H is empty)
however, if column H has a date, then it remains clear.
Last edited by DrewSB; 07-30-2010 at 03:06 PM.
Re: IF column C is > 14 days of todays date, turn red. if not, turn yellow.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1