Pages

Search

Excel IT Pro Discussions Forum: Conditional formatting using named cell in Excel 2010

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Conditional formatting using named cell in Excel 2010

Greetings,

I want to use a named cell in my Conditional Formatting rule. Let's call it "red_target".

I want to be able to tell the rule, "If cell value is greater than red_target, turn red."

When I type "=red_target" or "red_target" in the Value: field, it thinks I literally mean the string "red_target."

When I use the picker to navigate to that specific cell, it doesn't fill in the name. It uses the R1C1 absolute reference.

Any ideas on using named cells in Conditional Formatting rules?

Thanks,
Rachel

Excel Help Forum - Excel Programming / VBA / Macros: Define range of formula in VBA based in first blank cell

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Define range of formula in VBA based in first blank cell
Hello everybody, I'm not an expert in VBA, and I need help for the following problem: I have a column with a lot of values that must be summed. The number of filled rows for this column will vary. There is a blank row on the top of the column. So far I have this: Code:

Excel Help Forum - Excel General: If value is missing in any column, then cannot perform operation

Feed2Mail notification - new post on Excel Help Forum - Excel General
If value is missing in any column, then cannot perform operation
Hi, i need some help in figuring out this formula: in cell H3 i have: =SI(D3="","",D3-(E3+G3+C3)) but i want to see if there is missing value in C3 and/or D3 then the formula will output "Missing Value" instead of perfroming the operation. I have attached the excell sheet. Please help ,...

Office IT Pro General Discussions Forum: Sharing your calendar with specific people

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Sharing your calendar with specific people

the client would like to share his calender with his secretary and also be able to hide certain meeting from her.

CAn you please she me how to do this in step by step form please(step1,step 2,step 3, etc.)

Excel Help Forum - Excel Programming / VBA / Macros: VBA transfer data from one workbook to another

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
VBA transfer data from one workbook to another
how would i go about transferring data from one workbook to another? the starting data is in: workbook: "VEF LOGBOOKm working.xlsm" worksheet: "Finished" cell: b1 I need it to go to the first unused cell in column a in: workbook: "VEF SUMMARYm.xlsm"

Excel Help Forum - Excel General: Calculating the number of days which fall in financial year

Feed2Mail notification - new post on Excel Help Forum - Excel General
Calculating the number of days which fall in financial year
Hi All, Anyone know how I could split the number of days beween two dates by financial year? ie From To Amount Number of days which fall in 2011/12 financial year Number of days which fall in 2013/14 financial year invoice...

Excel IT Pro Discussions Forum: Excel 2010 - complicated formulas

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel 2010 - complicated formulas

Hi

I have a spreadsheet I'm just about happy with, but I need to tweak a formula slightly and I need a bit of help with it. In the cells in column F, the user either types in the Book Band number or if the child has reached above level 30 they are now a Free Reader and they typre Feee Reader into a cell in column F. A Free Reader has the reading age of someone 11y, 6m+.

In column G the formula works out how far ahead, behind or whether they are on target. Here is the formula:

=IF(TRIM(E2)=TRIM(G2),"On target",IF(INT(M2)<>0,INT(M2) & "y, ","") & ROUND(MOD(M2,1)*12,0) & "m" & IF(K2>L2, " behind"," ahead"))

I would like to adjust that formula to show the text in column H of "Way ahead" if a child is a Free Reader (11y, 6m+).

I'd really appreciate your help.

Viv

Viv Haig

Subscribe to: Comments (Atom)