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
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Apply conditional formatting to the selected cells ✓ - Excel Forum
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.
