IF THEN color cell red
 

Is it possible to set up an IF a cell value is 95% THEN shade the cell red?

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?

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?

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?