Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MS Excel formula
How can I fill color in one cell related to another cell values. For example:
If 10A10, A2 to be filled with yelow. If A1<0, A2 to be filled with red. I want to use this in a maintenance worksheet. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MS Excel formula
Select cell A2
From the menu bar, select Conditional Formatting Change the top left box from "Cell value is" to "Formula is". To the right of "Formula is" enter (without the quotes) "=A1<0" Click on "Format..." button Select Patterns tab Choose Colour OK "Sorin Danila" <Sorin wrote in message ... How can I fill color in one cell related to another cell values. For example: If 10A10, A2 to be filled with yelow. If A1<0, A2 to be filled with red. I want to use this in a maintenance worksheet. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MS Excel formula
Select cell A2, click on 'Format' on the top toolbar.
Click 'Conditional Formatting' Condition 1 On the first drop-down box select 'Formula Is' In the next box enter =A1<0 Click the 'Format' button, on the 'Patterns' tab select red colour. Click OK. Click the 'Add' button Condition 2 On the first drop-down box select 'Formula Is' In the next box enter =A10 Click the 'Format' button, on the 'Patterns' tab select yellow colour. OK out. Enter a value in cell A1. Hop this helps. George Gee "Sorin Danila" <Sorin wrote in message ... How can I fill color in one cell related to another cell values. For example: If 10A10, A2 to be filled with yelow. If A1<0, A2 to be filled with red. I want to use this in a maintenance worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Excel Formula Issue | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |