Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Kerri Gonzalez   on Jan 10 In MS Office Category.

  
Question Answered By: Vilmos Fischer   on Jan 10

So, Set a conditional format

in, say, C1
Format/Conditional Format
Condition: not equal to A1 (make sure you use A1 not $A$1)
Format: borders and shading, Fill, Red
Then copy this down from C1 however far you want to go. You can use the
format painter to do this if the cells  have already been filled.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Comparision between 2 cells Or get search suggestion and latest updates.


Tagged: