Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting a range of cells
Is it possible to conditional format (CF) a range of cells eg A1 to A50
depending on the contents of the cells B1 to B50? I want the individual cells in A1 to A50 to change when a value is eneterd into the individual cells B1 to B2, eg if I enter a date in B1 then contents of A1 changes to red, if I enter a date in B2 then contents of A2 changes to red etc etc. I know how to get it to change to red but it seems I have to CF each cell individually. ie A1 to B1, A2 to B2 etc etc. I have tried to copy and paste (format) cell A1 to cells A2 to A50 but these would always refernce back to B1 (Because A1 refers to B1) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting across many cells with a mobile comparison | Excel Discussion (Misc queries) | |||
Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
Formatting a range of cells doesn't work | Excel Discussion (Misc queries) | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) |