LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cond formatting Chris Excel Discussion (Misc queries) 1 May 9th 07 08:31 PM
Cond Format - 7 conditions Sarah Excel Discussion (Misc queries) 6 April 28th 07 08:20 AM
cond formatting ? Brian Excel Worksheet Functions 2 July 11th 06 04:12 PM
Cond formatting katmando Excel Discussion (Misc queries) 1 April 13th 06 02:20 PM
Cond Formatting & Validation Jonah Excel Discussion (Misc queries) 1 March 9th 06 10:55 PM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"