| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting a cell that has a formula
I have a list with a column (G) of answers ie (G3) =IMSUB(D3,F3) .etc
I am trying to colour code the answers ie <250 = green 250<500 = gold 500 = red the conditional formatting seems to only reconise the formula and not the answer in the cell Please help Regards Anthony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting if a cell contains a formula | Excel Worksheet Functions | |||
| Conditional formatting to a different cell and it contains a formula | Excel Worksheet Functions | |||
| Conditional Formatting on cell with a formula | Excel Worksheet Functions | |||
| Recognizing Cell Formatting To Use In A Formula Or Conditional For | Excel Worksheet Functions | |||
| Conditional Formatting if cell content is a formula | Excel Worksheet Functions | |||
Threaded Mode
