Thread: conditional formatting in an IF function?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Melvin Tang[_2_] Melvin Tang[_2_] is offline
external usenet poster
  
Posts: 4
Default conditional formatting in an IF function?
I have a set of specified values in two columns in worksheet 1: M1 = 1, M2 =
2, M3 = 3 etc... in Worksheet 2, i have two columns: Class (M1 to M10) and
Value (1 to 10). How do I, in Worksheet 2, highlight the cells that don't
match the specified value of the class (ie. M1 = 5)?
Reply With QuoteReply With Quote