Conditional Formatting in Excel
Closed
Zack
-
Apr 14, 2010 at 12:24 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 14, 2010 at 02:19 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 14, 2010 at 02:19 PM
Related:
- Conditional Formatting in Excel
- Marksheet format in excel - Guide
- How to change date format in excel - Guide
- Number to words in excel - Guide
- How to clear formatting in excel - Guide
- Gif in excel - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 14, 2010 at 01:16 PM
Apr 14, 2010 at 01:16 PM
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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 14, 2010 at 02:19 PM
Apr 14, 2010 at 02:19 PM
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