| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
conditional formatting based on column
In Excel2000, can I have a conditional format based on a formula
reference. For example, I have data in columns A and C. In column B I have formulas that reference either column A or C ( +A15 or +C19). Can Excel use conditional formatting to look at the formula and then format it one way if in column A (red fill) and another in column C (yellow fill). Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Some help with conditional formatting | Excel Discussion (Misc queries) | |||
| Trying to add conditional formatting to every other cell...GOING . | Excel Worksheet Functions | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| Conditional formatting based on text | Excel Worksheet Functions | |||
| Conditional Formatting based on month name | Excel Discussion (Misc queries) | |||
Threaded Mode
