Using Macro for conditional formatting
Closed
RA
-
Jan 1, 2012 at 08:01 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 2, 2012 at 01:27 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 2, 2012 at 01:27 AM
Related:
- Using Macro for conditional formatting
- Spell number in excel without macro - Guide
- Phone formatting software for pc - Download - File management
- Clear formatting in excel - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 2, 2012 at 01:27 AM
Jan 2, 2012 at 01:27 AM
the data is like this from columnsA to F
A B F
name rank experience
a lecturer 3
s senior lecturer 10
d professor 8
f lectuer 12
highlight column A from a to f
in conditinal formatting window
the cell value is
the next window
=AND(OR(B3="professor",B3="senior lecturer"),F3>9)
choose format-patern choose color
click ok
click ok
I assume that column F from F2 down are numbers
A B F
name rank experience
a lecturer 3
s senior lecturer 10
d professor 8
f lectuer 12
highlight column A from a to f
in conditinal formatting window
the cell value is
the next window
=AND(OR(B3="professor",B3="senior lecturer"),F3>9)
choose format-patern choose color
click ok
click ok
I assume that column F from F2 down are numbers