Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating - dragging a cond. format over an entire col
OK, I have 3 columns I am working with, I set up a conditional formula where
C1 B1 OR C1 A1 then turn C1 red font. I want to "somehow" drag this conditional format down the entire C column and have it automatically adjust to the rows, for example , like this; C2 B2 OR C2 A2, C3 B3 OR C3 A3 , etc. Kind of like when you enter a formula in a spreadsheet, then drag the formula over an entire column, and it adjusts accordingly. I tried using the format painter, but this does not work, it just applies the first formula to every cell in that column.. Any suggestions would be great!, Thanks A B C 7 6 5 4 5 6 8 4 7 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format in a List | Excel Discussion (Misc queries) | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
Conditional Format - 3 conditions | Excel Worksheet Functions | |||
Conditional Format to change entire row based on one cells data | Excel Discussion (Misc queries) | |||
How to change an entire row using conditional formating | Excel Discussion (Misc queries) |