| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally formatting a cell based on other cell values
I am trying to format a cell based upon the relationship of another cell to a
reference value. For instance if the reference is 5 and the other cell is 4 I want to format the original cell green, if it is the same blue and if it is less than the reference red. Can someone help please! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditionally formatting a cell based on other cell values
Please give a full explanation
-- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "ian" wrote: I am trying to format a cell based upon the relationship of another cell to a reference value. For instance if the reference is 5 and the other cell is 4 I want to format the original cell green, if it is the same blue and if it is less than the reference red. Can someone help please! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditionally formatting a cell based on other cell values
You can do this with conditional formatting. Say A1 is the cell you want
formatted, and B1 is your other cell. Then use: =a1b1 Select green color =a1=b1 Select blue color =a1<b1 Select red color If you need further help, post back with the version of Excel you are using, and the specifics on what cells you are using. Regards, Fred "ian" wrote in message ... I am trying to format a cell based upon the relationship of another cell to a reference value. For instance if the reference is 5 and the other cell is 4 I want to format the original cell green, if it is the same blue and if it is less than the reference red. Can someone help please! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditionally formatting a cell based on other cell values
What version of Excel are you using?
-- Biff Microsoft Excel MVP "ian" wrote in message ... I am trying to format a cell based upon the relationship of another cell to a reference value. For instance if the reference is 5 and the other cell is 4 I want to format the original cell green, if it is the same blue and if it is less than the reference red. Can someone help please! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditionally Formatting Cells based on Values in a Range (2007) | Excel Worksheet Functions | |||
| Cond. formatting, based on other cell values? | Excel Discussion (Misc queries) | |||
| Formatting cell based upon values w/in a selection | New Users to Excel | |||
| how can I conditionally format a cell based on the value in a diff | Excel Discussion (Misc queries) | |||
| Can I conditionally format a line based on a cell value | Excel Discussion (Misc queries) | |||
Linear Mode
