Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Excel 2008
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.) Thanks for your help! I |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Excel 2008
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Excel 2008
The second conditional formatting rule could be:
=and(h3="yes",j3="",k31) 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.) Thanks for your help! I -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difference between the dates ex: 4/11/2008- 7/11/2008= 3 days | Excel Worksheet Functions | |||
Excel 2008 (Mac): Conditional formatting criteria expanded? | Excel Worksheet Functions | |||
(Fussball Spiel EM 2008) [0/3] - "Fussball Spiele EM 2008.nzb" yEnc (1/1) | Excel Discussion (Misc queries) | |||
(Fussball Spiel EM 2008) [1/3] - "Fussball Spiele EM 2008.sfv" yEnc (0/1) | Excel Discussion (Misc queries) | |||
(Fussball Spiel EM 2008) [2/3] - "Fussball Spiele EM 2008.par" yEnc (1/1) | Excel Discussion (Misc queries) |