Thread
:
Conditional format question
View Single Post
#
3
Posted to microsoft.public.excel.misc
Richard
external usenet poster
Posts: 709
Conditional format question
Really!
"paul" wrote:
well the condition are different ie 5 vs 10 and 5000 vs 10000
--
paul
remove nospam for email addy!
"Richard" wrote:
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
Reply With Quote
Richard
View Public Profile
Find all posts by Richard