Thread: Conditional formatting based on Cell Value and another cell's valu
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nebulous Nebulous is offline
external usenet poster
  
Posts: 8
Default Conditional formatting based on Cell Value and another cell's valu
In Excel 2007...

If E50 and E3="x" I want E5 to be shaded red.

How can I accomplish this?

Even better would be:

If E50 and E3="x" I want E5 to be shaded "the same color as E3" (that is,
to use the shaading of E3 as a variable. Doubt that's possible).

Any help is GREATLY appreciated!

jb
Reply With QuoteReply With Quote