| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional Formatting
I'm getting stuck on something really basic. I want to compare the sum of
two cells with the value of one cell multiplied and, if greater, turn the cell red. I'm entering the formula and it's appearing as follows: =IF+$E$5:$E$6$E$4*2 It won't work. Anyone tell me what I'm doing wrong? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
