Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have 2 columns. C1 & H1. I am using the conditional format ting to format
column H1 to change color if the value in cell H1 is equal to the value in cell C1. how do copy this conditional format down the rest of the cell in column H1. I tried to copy and paste down the cell in column H1 but the equal value alway reference to C1 cell instead of C2, H2; C3, H3 and so on.. thx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation or Conditional Format (or combo of) | Excel Worksheet Functions | |||
Conditional format numbers | Excel Worksheet Functions | |||
Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
Conditional format of minimum number | Excel Worksheet Functions | |||
Conditional Format Question | Excel Worksheet Functions |