| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can i use cond formating to colour an entire column?
I have used conditional formating to highlight a cell in my table, but I
would like the entire column to be highlighted. e.g Table has NAME TARGET ACTUAL PERCENT TO TARGET MR O 450 300 66.6% I can highlight Cell D2 (percent to target) using cond format, but can i make the entire colum change colour? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formating - dragging a cond. format over an entire col | Excel Worksheet Functions | |||
| Conditional Formating an entire row | Excel Discussion (Misc queries) | |||
| Cond. Formating | Excel Worksheet Functions | |||
| Cond Formula for adding only cells of particular colour | Excel Worksheet Functions | |||
| copying table with cond.formating using value and resulting color | Excel Discussion (Misc queries) | |||
Threaded Mode
