Conditional Formatting
Closed
jacob
-
Jan 14, 2010 at 02:31 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 14, 2010 at 05:50 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 14, 2010 at 05:50 AM
Related:
- Conditional Formatting
- How to clear formatting in excel - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Phone formatting software for pc - Download - File management
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 14, 2010 at 05:50 AM
Jan 14, 2010 at 05:50 AM
In the conditional formatting window of H4use "the formula is"(instead of value is)
in the formula windowa
=g4>=.995 and click format and choose patterns and choose green
click ok once
then in the conditional format window
click add
and in the condition 2 type the otehr formula
choose formt-patter-color
click ok once
and again repeat the same for the third formula
click ok twice
in excel upto verions 2003 you can have only three conditions.
in the formula windowa
=g4>=.995 and click format and choose patterns and choose green
click ok once
then in the conditional format window
click add
and in the condition 2 type the otehr formula
choose formt-patter-color
click ok once
and again repeat the same for the third formula
click ok twice
in excel upto verions 2003 you can have only three conditions.
