if cell in row has color then return text

**TJ_IE** · 10-03-2014, 09:55 AM

Hi all

I have a userform that people input their specs

if it is out of spec that specific cell turns red

all new inputs are place in the next blank row

I was looking for some help to be able to get a FAIL or PASS depending if there is a red cell in a row or not

G through Z are where the specs are placed and AA is where the PASS or FAIL needs to be placed

**JOHN H. DAVIS** · 10-03-2014, 10:25 AM

Untested, try on a copy first.

Please Login or Register  to view this content.

**TJ_IE** · 10-03-2014, 11:51 AM

Thank you

but I seem to be having another problem now. Not sure what I did.

so now it's giving me an error here is the code for the color change I have

if I have the code just for q1m1 it works but if I place it on q1m2 as well it gives me an error

I am getting an error in the bold

Please Login or Register  to view this content.

**TJ_IE** · 10-03-2014, 01:08 PM

heeey it worked!

I messed around with the code a bit

placed the code that you provided and it worked like a charm

THANK YOU John!

**JOHN H. DAVIS** · 10-03-2014, 01:31 PM

You're welcome. Glad to help out and thanks for the feedback.

if cell in row has color then return text

LinkBack

Thread Tools

Rate This Thread

Display

if cell in row has color then return text

Re: if cell in row has color then return text

Re: if cell in row has color then return text

Re: if cell in row has color then return text

Re: if cell in row has color then return text

Thread Information

Users Browsing this Thread

Similar Threads

Macro to change cell text color based on darkness of cell fill color

How to filter cell by color in office 2003 (both background color and text color)

Excel 2007 : Formula return Text Color

Conditional format to change text color when the cell is manually given a fill color

change text color based on adjacent cell text color

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions