lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have 4 columns in a table which are Name. Dept, Address, Phone#
I want to create a conditional formatting rule. If a user enter in cell H1=Name then excel will highlight the name column in red, if user enter H1=Address then excel will highlight Address column in green etc.
How I did it, I highlighted Name column and then created CF rule = $H$1="Name"
and I repeated that 4 times for other columns.
Is there better way to do it? or this way does not like so dumb? Thanks a lot.
I have 4 columns in a table which are Name. Dept, Address, Phone#
I want to create a conditional formatting rule. If a user enter in cell H1=Name then excel will highlight the name column in red, if user enter H1=Address then excel will highlight Address column in green etc.
How I did it, I highlighted Name column and then created CF rule = $H$1="Name"
and I repeated that 4 times for other columns.
Is there better way to do it? or this way does not like so dumb? Thanks a lot.
