Conditional Formatting Excel 2008
You're my hero! Thank you so much. It worked!
PFABA, Ontario
"JE McGimpsey" wrote:
In article ,
PFABA wrote:
I am tryng to create Conditional Formatting with 3 conditions.
1) If J30 then format J3 light blue and stop
But if all 3 of the following conditions are true then format J3 dark blue
1) H3="Yes" (this field with have a "Yes" or "No" in it)
2) J3=0 (blank cell with no text)
3) K31 (this cell will have a 0 or 1 or 2 or 3 etc.)
One way:
Select J3. Choose Format/Conditional Formatting...
CF1: Cell Value is greater than 0
Format1: <patterns/<lt blue
CF2: Formula is =AND(COUNTA(J3)=0, H3="Yes",K31)
Format2: <patterns/<dk blue
|