View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] singletary.phx@gmail.com is offline
external usenet poster
 
Posts: 1
Default Two Separate Conditions for Cond. formatting

1st need: Shading every other row. I have this figured out.

2nd Need: (this is where problems begin) I need to CF so that the date
in the cell becomes red if it is 320 days old. I am using

"cell value is, less than, =TODAY()-320"

It works when it's alone, but when I use it WITH the 1st (above) CF,
it only works for every other row.

How can I combine these two to show BOTH every other row shaded and
turn red if it is older than 320 days old.

Thanks for the help. (I did search, I just couldn't find this
particular issue)