Conditional Formatting a single cell based on another range
Solved/Closed
hussar
Posts
2
Registration date
Sunday 20 October 2013
Status
Member
Last seen
20 October 2013
-
20 Oct 2013 à 03:22
hussar Posts 2 Registration date Sunday 20 October 2013 Status Member Last seen 20 October 2013 - 20 Oct 2013 à 07:51
hussar Posts 2 Registration date Sunday 20 October 2013 Status Member Last seen 20 October 2013 - 20 Oct 2013 à 07:51
Related:
- Based on values in cells b77 b81
- Based on the values in cells b77 - Excel Forum
- Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum
- Based on the values in cells b77 b81 c77 - Excel Forum
- Based on the values in cells b77:b81, which function can automatically return the value in cell c77? ✓ - Excel Forum
- How do I get a value in a cell based on another cell - Excel Forum
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
20 Oct 2013 à 07:31
20 Oct 2013 à 07:31
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 20 October 2013
Status
Member
Last seen
20 October 2013
20 Oct 2013 à 07:51
20 Oct 2013 à 07:51
Perfect. Thank you very much Mazzaropi
Have a great day
Kind Regards
Hussar
Have a great day
Kind Regards
Hussar
