Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an inventory that is being done manually with thousands of numbers.
I'd like to be able to identify quantities that haven't changed using a conditional format. What I don't want is to have to do each cell individually. Is there any way to set the first cell (Condition 1 (Cell Value Is equal to =$C$5) then highlight) and then copy each cell below so that the conditional format also changes? First cell is J5=C5 (highlight) then J6=C6, etc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional format won't copy | Excel Discussion (Misc queries) | |||
Copy Formula Is conditional format | Excel Worksheet Functions | |||
Copy & paste conditional format | New Users to Excel | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |