Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I use conditional formatting for an entire column? | Excel Discussion (Misc queries) | |||
Expanding Conditional Format Rule to entire Column | Excel Discussion (Misc queries) | |||
Applying Max Conditonal Formatting to an entire row when condition | Excel Worksheet Functions | |||
Conditional Formatting for an entire row or column? | Excel Worksheet Functions | |||
Applying a formula to an entire column | Excel Discussion (Misc queries) |