Conditional Formatting a single cell based on another range
Solved/Closed
hussar
Posts
2
Registration date
Sunday October 20, 2013
Status
Member
Last seen
October 20, 2013
-
Oct 20, 2013 at 03:22 AM
hussar Posts 2 Registration date Sunday October 20, 2013 Status Member Last seen October 20, 2013 - Oct 20, 2013 at 07:51 AM
hussar Posts 2 Registration date Sunday October 20, 2013 Status Member Last seen October 20, 2013 - Oct 20, 2013 at 07:51 AM
Related:
- Based on values in cells b77 b81
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
- Instagram account based in wrong country - Instagram Forum
- Insert picture in Excel macro which takes the file name refrence - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77 ✓ - Excel Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 20, 2013 at 07:31 AM
Oct 20, 2013 at 07:31 AM
Hussar, Good morning.
Select D100 cell.
At CONDITIONAL FORMATTING;
FORMULA --> =MATCH(D100,$B$7:$AD$7,0)
Choose your desired COLOR at Format.
I hope it helps.
Select D100 cell.
At CONDITIONAL FORMATTING;
FORMULA --> =MATCH(D100,$B$7:$AD$7,0)
Choose your desired COLOR at Format.
I hope it helps.
hussar
Posts
2
Registration date
Sunday October 20, 2013
Status
Member
Last seen
October 20, 2013
Oct 20, 2013 at 07:51 AM
Oct 20, 2013 at 07:51 AM
Perfect. Thank you very much Mazzaropi
Have a great day
Kind Regards
Hussar
Have a great day
Kind Regards
Hussar
