conditional format across cells with text

B

brett

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

Andy B

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Perplexed by simple Icon Set Cond. Formatting Issue 0
Conditional formatting code 1
Conditional Formatting to Another Cell 0
Conditional Formatting help (2003) 1
Conditional Formatting Help 1
Conditional Formatting 2
Copy conditional formatting across column in the same row 2
Excel 2010 Conditional Formatting 2

Top