| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying conditional formatting to cell based on another cell's in
Is this even possible? I've done conditional formatting to a cell based on
that same cell's info BUT what I want to do now is something like this...Can I apply conditional formatting to cell A3 based on the information in cell B3? If so, how do I do that?? I completely suck at writing formulas so, if you know the answer, can you help me with how to write the formula, too? Basically, I want to apply formatting to A3 if B3 has a value greater than zero. Thank you!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Applying conditional formatting to cell based on another cell's in
use "Formula is" and the formula is
=B30 "kdesemple" wrote: Is this even possible? I've done conditional formatting to a cell based on that same cell's info BUT what I want to do now is something like this...Can I apply conditional formatting to cell A3 based on the information in cell B3? If so, how do I do that?? I completely suck at writing formulas so, if you know the answer, can you help me with how to write the formula, too? Basically, I want to apply formatting to A3 if B3 has a value greater than zero. Thank you!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
| Can a conditional formatting result affect another cell or cells | Excel Worksheet Functions | |||
| Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
