View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
StinkyDesigns StinkyDesigns is offline
external usenet poster
 
Posts: 1
Default Conditional formatting - mutlple formats

Here is what I would like to do:

This is a 3 Condition on an entire row.

Row: A

Condition 1: If A5 is inputted with any date - then entire row becomes
Bold Blue Text

Condition 2: Then when any date is entered in J5 - the entire row
changes to red text

Condition 3: When any date is entered into cell L5 - the entire row
changes to bold black.


The problem is - it is only following condition 1. I tried various
formulas such as =if and and, but I can't figure out the correct
string. I was thinking perhaps an formula based on if condition 1 was
complete and then condition 2 is true.

Help... Thank you.