View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default CONDITIONAL FORMAT BASED ON 2 CELLS

Use this for FormulaIs:

=AND($A$6<"",$B$6="")

HTH,
Paul

"Steve_n_KC" wrote in message
...
Even to me this seems like it should be simple but I'm not able to make it
work:

Given A6:L6, I would like B6 through L6 (independent of each other) to be
shaded red IF A6 contains any value AND the 2nd cell is blank. If A6 is
blank OR second cell contains any value then no shading.
--
THANKS!

Steve