Conditional Formatting in Excel
Closed
Zack
-
14 Apr 2010 à 12:24
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 14 Apr 2010 à 14:19
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 14 Apr 2010 à 14:19
Related:
- Conditional Formatting in Excel
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- How to change date format in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Arrow keys not working in excel - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
14 Apr 2010 à 13:16
14 Apr 2010 à 13:16
How are you applying cond. format
Try this
based on you sample
select range B2:D6
goto conditional format and apply this formula
=ISERROR(MATCH(B2,A:A,0))
It looks at a cell and then see if that value exist to one column left to it
like value found in B2 if not in column A:A will be highlighted
Try this
based on you sample
select range B2:D6
goto conditional format and apply this formula
=ISERROR(MATCH(B2,A:A,0))
It looks at a cell and then see if that value exist to one column left to it
like value found in B2 if not in column A:A will be highlighted
rizvisa1 I have to admit my ignorance in regards to excel. I selected B2 through B24 and each subsequent column until coumn F2 through F24 to select the entire data range without headers. I then typed the formula you gave me into the fx box and nothing happened. I know I have done something wrong can you please advise further.
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
14 Apr 2010 à 14:19
14 Apr 2010 à 14:19
Zack, based on above, it seems to me that your data is between range A2:F24
So what i was trying to say was
Select you range (leaving out the starting point which would be A2:A24)
Then go to conditional Format
And paste the formula there. Then from the conditional format, click on format and choose the color of your choice
So what i was trying to say was
Select you range (leaving out the starting point which would be A2:A24)
Then go to conditional Format
And paste the formula there. Then from the conditional format, click on format and choose the color of your choice