Conditional formatting of a cell if another cell is blank
Closed
Ant104
Posts
3
Registration date
Wednesday November 6, 2013
Status
Member
Last seen
November 6, 2013
-
Nov 6, 2013 at 05:24 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 7, 2013 at 01:42 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 7, 2013 at 01:42 AM
Related:
- Conditional formatting if another cell contains any text
- Conditional formatting if another cell contains - Best answers
- Conditional formatting excel if another cell contains text - Best answers
- Conditional formatting if cell contains text - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- If a cell has text then return value ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
4 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 6, 2013 at 08:02 AM
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