Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with conditional formatting 3 criteria
I want odd columns to use a red font, and even columns to use a blue
font. I have this working now using two conditional formatting criteria. Now I want to add another criteria that formats any negative values in an even column to have a yellow background, but I can't get it to work. I tried something like =AND(MOD(COLUMN(),2)=0,A1<0) as the 3rd criteria of the type FORMULA IS. I thought this would work, but it doesn't. In fact, that above criteria doesn't even work when used all by itself on another sheet. Have I run into undocumented limitations of conditional formatting? Thanks, Brian Murphy Austin, Texas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with more than 3 Criteria | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Can I set more than three criteria for conditional formatting? | Excel Worksheet Functions | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) |