Conditional formatting of a cell if another cell is blank
Closed
Ant104
venkat1926
- Posts
- 4
- Registration date
- Wednesday November 6, 2013
- Status
- Member
- Last seen
- November 6, 2013
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Excel conditional formatting if another cell contains specific text
- Excel conditional formatting if cell contains specific text - Best answers
- Conditional formatting if another cell is blank - Best answers
- How to use conditional format based on text? ✓ - Forum - Excel
- Conditional format based on another cell containing text - Forum - Excel
- Highlight cell if another cell contains any text ✓ - Forum - Excel
- Conditional formatting with multiple rules and blank text cells ✓ - Forum - Excel
- Excel conditional formatting if another cell is between two values ✓ - Forum - Excel
4 replies
venkat1926
Nov 6, 2013 at 08:02 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Nov 6, 2013 at 08:02 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(E2="tier 2",L2="")
and then do whatever formal lyou want.
\
copy M2 down pastespecial -format
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(E2="tier 2",L2="")
and then do whatever formal lyou want.
\
copy M2 down pastespecial -format
Ant104
Nov 6, 2013 at 11:24 PM
- Posts
- 4
- Registration date
- Wednesday November 6, 2013
- Status
- Member
- Last seen
- November 6, 2013
Nov 6, 2013 at 11:24 PM
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.
thanks Ant
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.
thanks Ant
Ant104
Nov 6, 2013 at 11:56 PM
- Posts
- 4
- Registration date
- Wednesday November 6, 2013
- Status
- Member
- Last seen
- November 6, 2013
Nov 6, 2013 at 11:56 PM
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"
or E8 "Tier 2"
venkat1926
Nov 7, 2013 at 01:42 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Nov 7, 2013 at 01:42 AM
for the first if F2>=toay() and F8 is "booked" then conditionla formatting(CF) formula is
=AND(F2>=TODAY(),$F$8="booked")
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
=AND(F2>=TODAY(),$F$8="booked")
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