View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vince Pacella Vince Pacella is offline
external usenet poster
 
Posts: 1
Default Conditional Formatting Applying Rule to Entire Column

I have three columns that I'm concerned with A, B, C

Column A is what I want to format with coloriing. It's Value is irrelevent.

For A2
The Condition is "Green" colors if formula =EXACT(B2,C2)
The Condition is "RED"colors if formula =EXACT(B2,C2) == FALSE

That works fine.

In Manage Rules it says
Applies: $A$2
Forumla: =EXACT(B2,C2)

It's when I copy/paste the format down column A for teh thousands of rows
that I get a single rule made:

Applies to: $A$3:$A$5000
Foruma: =EXACT($B3:$C3)

I tried playing with the dollar signs, but I can never get the Formula to
have the right row reference for a given row in the range