please help me

Jagat Pavasia

Board Regular
Joined
Mar 9, 2015
Messages
168
I have some text and digit in A1 to J1, but i want that if i type "O.K." in K1 then all line A1 to J1 changed to Blue Color.
 

lrobbo314

Well-known Member
Joined
Jul 14, 2008
Messages
2,627
Office Version
365, 2019, 2016
Platform
Windows
Select the data in Columns A-J and add a Conditional Format. Add a formula as your conditional format. The formula is =$K1="O.K."

Then just choose a blue background color.
 

Forum statistics

Threads
1,085,544
Messages
5,384,364
Members
401,889
Latest member
Pmccollin

Some videos you may like

This Week's Hot Topics

Top