IF THEN color cell red

[NHOWARDUT]

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

 

[Don Guillett]

95% of WHAT?

Use format>conditional formatting

 

[Bob Phillips]

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)

 

[Alan]

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.