Format Range of Cells Based Off Another Range of Cells
Closed
JC
-
Mar 14, 2013 at 07:45 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 16, 2013 at 11:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 16, 2013 at 11:54 AM
Related:
- Format Range of Cells Based Off Another Range of Cells
- Apple airtag range - Guide
- Format factory - Download - Other
- Excel macro to create new sheet based on value in cells - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- How would you change all cells containing the word pass to green - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 15, 2013 at 07:03 AM
Mar 15, 2013 at 07:03 AM
try combination of IsError and Match in conditional format
jpppol
Posts
13
Registration date
Wednesday February 27, 2013
Status
Member
Last seen
July 30, 2013
1
Mar 15, 2013 at 03:06 PM
Mar 15, 2013 at 03:06 PM
1. highlight the range B:Z you want to apply the conditional formatting to
2. on the home tabe, styles, select CF
3. select new rule, select value in cell is
4. select equal
5. select A1
6. select colour
and repeat it but in 5 point chose A2 and again repeat
2. on the home tabe, styles, select CF
3. select new rule, select value in cell is
4. select equal
5. select A1
6. select colour
and repeat it but in 5 point chose A2 and again repeat
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 16, 2013 at 11:54 AM
Mar 16, 2013 at 11:54 AM
You dont have to add so many condition
All you have to do is first match in A column. If there is no match, then there would be error. Otherwise you would not have any error. You can trap that to format the cell
All you have to do is first match in A column. If there is no match, then there would be error. Otherwise you would not have any error. You can trap that to format the cell