Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF THEN color cell red
Is it possible to set up an IF a cell value is 95% THEN shade the cell red?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF THEN color cell red
95% of WHAT?
Use formatconditional formatting -- Don Guillett Microsoft MVP Excel SalesAid Software "NHOWARDUT" wrote in message ... Is it possible to set up an IF a cell value is 95% THEN shade the cell red? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF THEN color cell red
See http://www.contextures.com/xlCondFormat01.html
-- --- HTH Bob __________________________________________ UK Cambridge XL Users Conference 29-30 Nov http://www.exceluserconference.com/UKEUC.html (there's no email, no snail mail, but somewhere should be gmail in my addy) "NHOWARDUT" wrote in message ... Is it possible to set up an IF a cell value is 95% THEN shade the cell red? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF THEN color cell red
Select the cell and click Format on the top Toolbar, select 'Conditional
Formatting' In the dialogue box that appears, select 'Cell Value Is' on the left and 'Greater than or equal to' in the middle (I'm presuming that you want the cell to react if its 95% or more, if you want only 95%, select 'Equal to') In the right hand box enter 0.95 Click 'Format' and set the cell colour to red. Regards, Alan. "NHOWARDUT" wrote in message ... Is it possible to set up an IF a cell value is 95% THEN shade the cell red? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) |