Conditional Formatting based on other cells
Closed
osiron23
Posts
1
Registration date
Thursday October 20, 2016
Status
Member
Last seen
October 20, 2016
-
Oct 20, 2016 at 11:58 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 21, 2016 at 08:30 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 21, 2016 at 08:30 AM
Related:
- Conditional Formatting based on other cells
- Based on the values in cells b77 ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
- "Publish your article in rss format for other websites to syndicate" ✓ - Internet & Social Networks Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Problem connecting certain websites ✓ - Internet & Social Networks Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 21, 2016 at 08:30 AM
Oct 21, 2016 at 08:30 AM
osiron23, Good morning.
Welcome here!
Try to use:
Select B1:K2
Conditional Format Menu --> Using Formula
Rule 1
=$A1=B1
Format:
Font BOLD, WHITE
Fill Color GREEN
OK
Rule 2
=$A1<>B1
Format:
Font BOLD, WHITE
Fill Color RED
OK
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Welcome here!
Try to use:
Select B1:K2
Conditional Format Menu --> Using Formula
Rule 1
=$A1=B1
Format:
Font BOLD, WHITE
Fill Color GREEN
OK
Rule 2
=$A1<>B1
Format:
Font BOLD, WHITE
Fill Color RED
OK
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
