conditional format across cells with text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to create a conditional format that says if a2="jason", then turn a1 red. Can this be done
Thanks!!
 
Hi

Select cell A1. Then Format / Conditional Formatting. With 'Formula is'
showing on the left, type
=A2="jason"
in the next box. Set your colour on the pattern tab and click OK

--
Andy.


brett said:
I am attempting to create a conditional format that says if a2="jason",
Click to expand...
then turn a1 red. Can this be done?
 
Back
Top