Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format question
When I select and conditional format column A, and then when I conditional
format column B using some of the same cells in column A the conditional formatting no longer works for the other column. Here's my formula for column A: =OR(LEFT($F$1,1)="5",$O$1=5000) Here's my formula for column B: =OR(LEFT($F$1,1)="10",$O$1=10000) If column A criteria is met, everything works fine If column B is met then column A stops working |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format | Excel Discussion (Misc queries) | |||
#N/A conditional format | Excel Worksheet Functions | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Conditional format problem | Excel Discussion (Misc queries) |