Conditional Formatting

C

Chris Watts

I am trying to come to grips with Conditional Formatting in Excel 2007 and
would welcome suggestions for the following.

If a cell contains two lines of text (normally seperated by an Alt CR) then
set colour (fill) of the next cell in the row.
If a cell contains only one line of text then set colour (fill) of the next
cell in the row to a different colour.
If a cell contains a fill of a particular coolur then remove fill from all
previous cells in that row.

TIA
Chris
 

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

Conditional Formatting 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
conditional formatting 1
Conditional formatting based on formula cell 4
Advanced conditional formatting 1
Changing row background from external program 0
Mail Merge Directory Conditional Page Break 0
How can i put text in a cell depending on colour 0

Top