Conditional formatting of a cell if another cell is blank [Closed]
4 Registration date
Wednesday November 6, 2013
Member Last seen
November 6, 2013
Nov 6, 2013 at 05:24 AM
- Latest reply:
1862 Registration date
Sunday June 14, 2009
Contributor Last seen
July 30, 2015
Nov 7, 2013 at 01:42 AM
I woner whether conditiona formattsing cell and critiera cell can eb same
select M2 clilck home-conditoan formatting-manage rules-new rule-use a formula tol determibe.........-, below the snmall window tregardixng formula type the formula
and then do whatever formal lyou want.
copy M2 down pastespecial -format
Brilliant thank you venkat.........
if I may as another question, I also want to do a conditional format of a cell based on a date.
example Cell B8 has a date in it of lets say 20 Nov 2013
i would like to format the cell as following
1) Green if the date is = or older than todays date IF an other specific cell (F8) has "Booked" in it.
2) then if the date of the cell is in the past (and not having the text of "Booked" in F8) the the cell must turn red
3) if the date in B8 is within 10 days of today date then cell must turn yellow
4) if the date in cell B8 is between 11 ~ 20 days then turn orange
if you could help it would be great.
one more question I would also like the cell B8 to turn blue if the date in that cell is due within the next 30 days and cell G8 does not have a specific text in it lets say "Agreed"
or E8 "Tier 2"
for the first if F2>=toay() and F8 is "booked" then conditionla formatting(CF) formula is
select F2 anbd then type the fo;rmla in CF
format as you like
I wonder why you are haveing in columnF boit date and string. in excel lit is better to use a column for a particular variable unless it is absolutely necessary
based aon above formula lcan you try other conditions?
any problem revert to newsgroup