Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Paste conditional formatting
hi,
I have conditional formating on cell T17 condition is if sum of B17 to S17 is greater than 0.5 then the cell T17 should turn red (or specified color). I am using this equation =Sum(T17:S17) Condition is working fine on T17. I need to copy the same conditional formatting to T18, T20, T21, T23, T24, T26, T27 etc. I tried copy and paste special but it wont copy conditional formatting. Is there another way to copy paste? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy conditional formatting, paste format without conditions | Excel Discussion (Misc queries) | |||
How to copy and paste conditional formatting for the cell next to | Excel Discussion (Misc queries) | |||
Conditional formatting - copy & paste to an email | Excel Discussion (Misc queries) | |||
Copy paste Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy Paste Conditional Formatting | Excel Discussion (Misc queries) |