| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting = or cell reference + 2
I would like to set up CF to change the font color to red if the value
(b2:b7) is = or greater than the cell reference (b:8)+2. What is the formula? Ex. only B7 would change to red font. A B 1Chart Dates 101 OR - Place Orders 2Mon 2/15 12.75% 3Tues 2/16 15.40% 4Wed 2/17 16.23% 5Thurs 2/18 14.11% 6Fri 2/19 15.48% 7Sat 2/20 23.01% 8Average 16.16% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting offset reference | Excel Worksheet Functions | |||
| reference another cell in conditional formatting | Excel Worksheet Functions | |||
| cell reference changes and conditional formatting | Excel Worksheet Functions | |||
| Conditional formatting a full row triggered by a single cell reference... | Excel Worksheet Functions | |||
| Conditional Formatting, reference another column | Excel Worksheet Functions | |||
Threaded Mode
