Conditional Formatting
Hi, I want to be able to specify the colour of a cell depending on the information in a different cell. Ie if the result is 7 or above the other cell will be yellow, but if the result is above 14 the cell will become red. any ideas? Matt |
Conditional Formatting
In the cell you want conditionally formatted, Format Conditional
Formatting. Set the condition to read 'Formula is' =$A$17 and set the condition you want. (Substitute your 'different cell' where I put A1). "mattguerilla" wrote: Hi, I want to be able to specify the colour of a cell depending on the information in a different cell. Ie if the result is 7 or above the other cell will be yellow, but if the result is above 14 the cell will become red. any ideas? Matt |
Conditional Formatting
I have done this already but the problem comes when the result is higher than
14. It should go red but it stays yellow. ??? Matt "bpeltzer" wrote: In the cell you want conditionally formatted, Format Conditional Formatting. Set the condition to read 'Formula is' =$A$17 and set the condition you want. (Substitute your 'different cell' where I put A1). "mattguerilla" wrote: Hi, I want to be able to specify the colour of a cell depending on the information in a different cell. Ie if the result is 7 or above the other cell will be yellow, but if the result is above 14 the cell will become red. any ideas? Matt |
Conditional Formatting
The format gets set by the first condition satisfied. So in your case, make
the test for =14 (the more restrictive test) the first condition and the test for =7 the second. "mattguerilla" wrote: I have done this already but the problem comes when the result is higher than 14. It should go red but it stays yellow. ??? Matt "bpeltzer" wrote: In the cell you want conditionally formatted, Format Conditional Formatting. Set the condition to read 'Formula is' =$A$17 and set the condition you want. (Substitute your 'different cell' where I put A1). "mattguerilla" wrote: Hi, I want to be able to specify the colour of a cell depending on the information in a different cell. Ie if the result is 7 or above the other cell will be yellow, but if the result is above 14 the cell will become red. any ideas? Matt |
All times are GMT +1. The time now is 09:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com